﻿--select * from DBOrderService.DBOrderService;
--select * from DBOrderService.DBOrder order by TimeStamp desc;
--select * from DBOrderService.DBOrderExecution order by TimeStamp desc,DBOrderID;
--select * from DBOrderService.DBOrderStatus order by TimeStamp desc,DBOrderID;

-- select * from DBOrderService.DBOrderService
select * from DBOrderService.DBOrder;
select * from DBOrderService.DBOrderExecution;
--delete from DBOrderService.DBOrder;
--delete from DBOrderService.DBOrderStatus;
--delete from DBOrderService.DBOrderExecution;
		
--execute [DBOrderService.spPosition] '2009-01-01' , '2010-31-12' , '\%'
--execute [DBOrderService.spPosition] '2009-01-01' , '2010-31-12' , '\%IBMvsDELL'
--execute [DBOrderService.spPosition] '2009-01-01' , '2010-31-12' , '\%IBMvsMST'